Create New Item
Item Type
File
Folder
Item Name
Search file in folder and subfolders...
Are you sure want to rename?
File Manager
/
reeft_gps_test
/
REEFTintegrationLog
/
saved
:
hub_webcnt_maintain.php
Advanced Search
Upload
New Item
Settings
Back
Back Up
Advanced Editor
Save
<?php //====================================================================================== // // Function: Maintain HUB_WEBCNT // // Programmer: JKJ // Date : 2024-12-02 // // Copyright Reeft A/S (c) - 2024 //====================================================================================== //====================================================================================== // Get input //====================================================================================== if (isset($_REQUEST["HUB_SERTYP"])) { $HUB_SERTYP = $_REQUEST["HUB_SERTYP"]; } else { $HUB_SERTYP = ''; } //====================================================================================== // Make line uppercase //====================================================================================== //====================================================================================== // General config //====================================================================================== include "config/config.php"; //====================================================================================== // Check if user is logged in? //====================================================================================== include "login_check.php"; //====================================================================================== // Get session variables //====================================================================================== include "include/getsession.php"; // include "include/uuid_create.php"; // include "include/generate_password_md5.php"; //====================================================================================== // Set language //====================================================================================== include "include/set_language.php"; //====================================================================================== // Set defaults //====================================================================================== // $pk_reference = $_SESSION['session_dft_pk_reference']; // $referenceCode = $_SESSION['session_dft_referencecode']; // $referenceName = $_SESSION['session_dft_referencename']; //====================================================================================== ?> <!DOCTYPE html> <html lang="en"> <head> <title><?php echo $datahub_text0001 ?></title> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <meta name="description" content="REEFTvisual - Stoptime"> <meta name="author" content="REEFT A/S"> <link rel="icon" href="images/favicon/favicon.ico"> <!-- Bootstrap / jQuery --> <link href="css/bootstrap4.3.1/css/bootstrap.custom.min.css" rel="stylesheet"> <link href="css/bootstrap4.3.1/css/themes/bootstrap.custom.min.css" rel="stylesheet"> <link href="css/bootstrap4.3.1/css/normalize.css" rel="stylesheet" type="text/css"> <link href="css/sticky-footer.css" rel="stylesheet" type="text/css"> <!-- Custom styles for this template --> <link href="css/custom.css" rel="stylesheet"> <link href="css/style.css" rel="stylesheet"> <script src="css/fontawesome6.5.1/js/all.min.js"></script> <script src="css/fontawesome6.5.1/js/sharp-light.min.js"></script> <script src="css/fontawesome6.5.1/js/sharp-regular.min.js"></script> <script src="css/fontawesome6.5.1/js/sharp-solid.min.js"></script> <script src="css/fontawesome6.5.1/js/sharp-thin.min.js"></script> <link href="css/bootstrap_animation/css/animate4/animate.css" rel="stylesheet" type="text/css"> <!--<link href="javascript/chosen/chosen.css" rel="stylesheet" type="text/css">--> <link href="javascript/jquery-ui/jquery-ui.min.css" rel="stylesheet" type="text/css"/> <script src="javascript/jquery.js"></script> <script src="css/bootstrap4.3.1/js/popper.js"></script> <script src="css/bootstrap4.3.1/js/bootstrap.min.js"></script> <script src="javascript/jquery-ui/jquery-ui.min.js"></script> <script src="javascript/jquery.ui.touch-punch.min.js"></script> <link href="javascript/bgrins-spectrum/spectrum.css" rel="stylesheet" type="text/css"> <script src="javascript/bgrins-spectrum/spectrum.js"></script> <script src="javascript/moment.min.js"></script> <script src="javascript/moment-with-locales.min.js"></script> <script src="javascript/moment-duration-format.min.js"></script> <script src="javascript/number_format/jquery.number.min.js"></script> <script src="javascript/jquery.scrollTo.min.js"></script> <!-- Data tables start --> <link href="javascript/datatables.3.12/datatables.min.css" rel="stylesheet"> <script src="javascript/datatables.3.12/datatables.min.js"></script> <!-- Data tables end --> <script src="javascript/chosen/chosen.jquery.min.js" type="text/javascript"></script> <script src="javascript/viewer-master/dist/viewer.min.js"></script> <link href="javascript/viewer-master/dist/viewer.min.css" rel="stylesheet"> <script src="javascript/ajaxq/ajaxq.js"></script> <link id="scrollUpTheme" rel="stylesheet" href="javascript/scrollup-master/dist/css/themes/image.css"> <script src="javascript/scrollup-master/dist/jquery.scrollUp.js"></script> <script src="javascript/shortcut.js"></script> <script src="javascript/_reeft_js/set_font_awesome_icon_type.js"></script> <script src="javascript/_reeft_js/date_convert.js"></script> <style> .btn-custom-wide { height:60px; width:210px; } .text-truncate-dt { max-width: 450px; white-space: nowrap; overflow: hidden; text-overflow: ellipsis; } .text-align-center-dt { text-align: center; } .text-align-left-dt { text-align: left; } .text-align-right-dt { text-align: right; } .modal-xxl { max-width: 80%; } .modal-xl { max-width: 50%; } .border-3 { border-width:3px !important; } td .hover-img { position:relative; } td .hover-img span { position:absolute; left:-9999px; top:-9999px; z-index:9999; } td:hover .hover-img span { top: 5px; left:0px; } .chosen-container-single { min-width: 100%; } </style> <script language="JavaScript"> //============================================================================= // Globals //============================================================================= var thisCurrentRow; var thisGlobalRowData; var thisGlobalTableData; var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_A = 'Text/Char'; var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_N = 'Number/Value'; var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_L = 'Date (ISO)'; var GLOBAL_CONFIG_TYPE_BUTTON_TEXT_T = 'Time (ISO)'; // Save field var save_HUB_WEBNAM = ''; var save_HUB_SERTYP = ''; var global_debug = 'N'; // Add allowed Y/N var GLOBAL_ADD_ALLOWED = 'N'; // Show group buttons var GLOBAL_SHOW_GROUP_BUTTONS = 'Y'; // Delete allowed Y/N var GLOBAL_DELETE_ALLOWED = 'N'; // sortMode var GLOBAL_SORTMODE = 'DESC'; var jsonDataSave = {}; var DFT_DATE_DISPLAY_FORMAT = '<?php //echo $DFT_DATE_DISPLAY_FORMAT ?>'; var DFT_LANGUAGE = '<?php //echo $DFT_LANGUAGE ?>'; var GLOBAL_TOTALPAGESSTOPVALUE = 10; // Save field //var save_CFGNAM = ''; $(function () { $.scrollUp({ scrollName: 'scrollUp', // Element ID //topDistance: '1800', // Distance from top before showing element (px) //topSpeed: 300, // Speed back to top (ms) scrollDistance: '300', // Distance from top before showing element (px) scrollSpeed: 300, // Speed back to top (ms) animation: 'fade', // Fade, slide, none animationInSpeed: 200, // Animation in speed (ms) animationOutSpeed: 200, // Animation out speed (ms) scrollText: false, //'Scroll to top', // Text for element activeOverlay: false, // Set CSS color to display scrollUp active point, e.g '#00FFFF' }); }); //============================================================================= // Get data //============================================================================= function getData( inputGetData ) { // Reset, show all if ( inputGetData == '*RESET' ) { inputGetData = ''; //Clear search thisGlobalTableData.search( '' ); } //Only initialize datatables once, else just draw it if ( $.fn.dataTable.isDataTable( '#REEFTvisual_data' ) ) { console.log('1'); thisGlobalTableData.draw(); // fire in the hole } else { console.log('2'); setDataTables(); } } //============================================================================= // Set datatables //============================================================================= function setDataTables() { // Delete allowed? if ( GLOBAL_DELETE_ALLOWED == 'Y' ) { var show_the_delete_button = true; } else { var show_the_delete_button = false; } parmData = ''; new $('#REEFTvisual_data').DataTable({ "ajax": { "url": 'hub_webcnt_maintain_get.php', "type": "POST", "data": function (parmData) { // Add custom parameters to the ajax call var input_HUB_SERTYP = $('#input-HUB_SERTYP').val(); parmData.HUB_SERTYP = input_HUB_SERTYP; parmData.callType = '*DATA'; parmData.orderBy = '1'; }, dataSrc: function (jsonData) { //return data var rpyCMPNO = jsonData.header.rpyCMPNO; var rpyCMPNO_Name = jsonData.header.rpyCMPNO_Name; var rpyFile_name = jsonData.header.rpyFile_name var rpyFile_description = jsonData.header.rpyFile_description var rpyTableRecordsFound = jsonData.header.rpyTableRecordsFound var returnCode = jsonData.header.returnCode; var returnMsg = jsonData.header.returnMsg; var entries_found = jsonData.header.entries_found; var response_sec = jsonData.header.response_sec; // Show load time $('#text-total-records-found').html( rpyTableRecordsFound ); $('#load-time-from-database').html('entries found: ' + entries_found + ' (' + response_sec + ')'); // Set Company and file information if ( rpyFile_name != '' ) { $('#data-hub-company-information').html( '<span title="' + rpyFile_name + ' - ' + rpyFile_description + '">' + rpyCMPNO_Name + ' (' + rpyCMPNO + ')' + '</span>' ).css('font-size','1.3em'); } // Init button line fields var HTMLlineButtons = ''; var HTMLlineButtonsModal = ''; var selectedButtonClass = 'btn-dark'; //===================================================================================== // Create group buttons, only if wanted //===================================================================================== if ( GLOBAL_SHOW_GROUP_BUTTONS == 'Y' ) { $.each( jsonData.header_buttons, function( index, object ){ var buttonLine = object.buttonLine; var buttonCount = object.buttonCount; // if ( input_HUB_WEBNAM == buttonLine ) { // selectedButtonClass = 'btn-success'; // } else { // selectedButtonClass = 'btn-dark'; // } selectedButtonClass = 'btn-dark'; var selectButtonLineID = 'select-button-line-id-' + buttonLine; var selectButtonLineIDmodal = 'select-button-line-id-modal-' + buttonLine + '_' + buttonCount; HTMLlineButtons += '<button type="button" onclick="setWebserviceSearch(\'' + buttonLine + '\')" style="cursor:default" id="' + selectButtonLineID + '" class="btn ' + selectedButtonClass + ' select-button-line btn-sm mr-1 mb-1">' + buttonLine + ' (<b>' + buttonCount + '</b>)' + '</button>' HTMLlineButtonsModal += '<button type="button" onclick="selectGroupValueModal(\'' + buttonLine + '\')" style="width:100px" id="' + selectButtonLineIDmodal + '" class="select-button-line-modal btn btn-primary btn-sm mr-1 mb-1">' + buttonLine + '</button>' }); // Reset HTMLlineButtons += '<button type="button" onclick="setWebserviceSearch(\'' + '' + '\')" style="cursor:default" id="' + 'RESET' + '" class="btn ' + 'btn-warning' + ' select-button-line btn-sm mr-1 mb-1">' + '<b>' + 'RESET' + '</b>' + '</button>' $('#data-result-button-group').html(HTMLlineButtons); $('#data-result-button-group-modal').html(HTMLlineButtonsModal); } //===================================================================================== return jsonData.data; } }, searching: true, processing: true, serverSide: true, responsive: true, fixedHeader: true, order: [[ 0, "asc" ]], columns: [ { data: "HUB_WEBNAM" }, // 0 { data: "HUB_LSTCAL" }, // 1 { data: "HUB_DESCP_FULL" }, // 2 { data: "HUB_COUNT" }, // 3 { data: "HUB_SERTYP" }, // 4 { // 5 // Since we are combining multiple data fields, use null as the data source data: null, render: function (data, type, row, meta) { // Create report button var HUB_CHRCOL = row.HUB_CHRCOL; var HUB_CHRCOL_TEXT = ''; HUB_CHRCOL_TEXT = '<div style="display:block;margin:auto;width:25px;height:25px; background-color:' + HUB_CHRCOL + '"> </div>'; return HUB_CHRCOL_TEXT; } }, { data: "HUB_CHRTXT" }, // 6 { data: "HUB_CHRMIN" }, // 7 { data: "HUB_CHRMAX" }, // 8 { // 9 // Since we are combining multiple data fields, use null as the data source data: null, render: function (data, type, row, meta) { if ( row.HUB_SHWCHT == 'N' ) { HUB_SHWCHT_text = '<?php echo $datahub_NO ?>'; } else { HUB_SHWCHT_text = '<?php echo $datahub_YES ?>'; } // Create edit button return HUB_SHWCHT_text; } }, { // 10 // Since we are combining multiple data fields, use null as the data source data: null, render: function (data, type, row, meta) { // Create edit button var myButton = '<button id="edt-' + row.HUB_WEBNAM + '-' + row.HUB_SERTYP + '" class="edit-btn btn btn-primary btn-block text-truncate xmr-1"><?php echo $datahub_button_edit_no_icon ?></button>'; return myButton; } }, { // 11 // Since we are combining multiple data fields, use null as the data source data: null, render: function (data, type, row, meta) { // Create delete button var myButton = '<button id="dlt-' + row.HUB_WEBNAM + '-' + row.HUB_SERTYP + '" class="delete-btn btn btn-danger text-truncate btn-block xmr-1"><?php echo $datahub_button_delete ?></button>'; return myButton; } }, { // 12 // Since we are combining multiple data fields, use null as the data source data: null, render: function (data, type, row, meta) { // Create delete button var myButton = '<button id="dlt-' + row.HUB_WEBNAM + '-' + row.HUB_SERTYP + '" class="show-trans-btn btn btn-primary text-truncate btn-block xmr-1"><?php echo $datahub_button_transactions_no_icon ?></button>'; return myButton; } }, { // 13 // Since we are combining multiple data fields, use null as the data source data: null, render: function (data, type, row, meta) { // Create delete button var myButton = '<button id="dlt-' + row.HUB_WEBNAM + '-' + row.HUB_SERTYP + '" class="show-chart-trans-btn btn btn-primary btn-block text-truncate xmr-1"><?php echo $datahub_button_chart_no_icon ?></button>'; return myButton; } }, { data: "HUB_DBGVAL" }, // 14 { data: "HUB_DESCP1" }, // 15 { data: "HUB_DESCP2" }, // 16 { data: "HUB_CHRCOL" }, // 17 { data: "HUB_SHWCHT" } // 18 ], columnDefs: [ // Make sure that buttons are not "hided" when responsive kicks in { responsivePriority: 10, targets: 8 }, { responsivePriority: 20, targets: 7 }, { responsivePriority: 30, targets: 6 }, { responsivePriority: 40, targets: 5 }, { responsivePriority: 50, targets: 4 }, { responsivePriority: 60, targets: 3 }, // Make sure the sorts toggle asc/desc and not asc/desc/no-sort //{ orderSequence: ['asc', 'desc'], targets: [3] }, { orderSequence: ['asc', 'desc'], targets: ['_all'] }, { "targets": [ 11 ], "visible": show_the_delete_button, "searchable": false, "orderable": false }, { "targets": [ 2,3 ], "max-width": '120px', "className": "text-truncate-dt" //class to mimic text-truncate in dt }, { "targets": [ 5,10,12,13 ], "visible": true, "searchable": false, "orderable": false }, { "targets": [ 14,15,16,17,18 ], "visible": false, "searchable": false, "orderable": false }, { "targets": [ 3,4,9 ], "className": "text-align-center-dt" }, ], pageLength: 10, lengthChange: true, layout: { top1Start: [{ pageLength: { menu: [10, 25, 50, 100] } }], top1End: [{ search: { placeholder: '<?php echo $datahub_datatable_Search_text ?>', processing: true } }], topStart: { info:{ } }, topEnd: { paging: { buttons: 7, firstLast: true, boundaryNumbers: true, } }, bottomStart: { buttons: [ { extend: 'copyHtml5', text: '<img src="images/copy.png" height="25"> Copy to Clipboard', titleAttr: 'Copy', title: 'DATAHUB - Webservice Data Export - Copy to clipboard', exportOptions: { // Fields to export (https://datatables.net/reference/button/csv#Examples) columns: [0,1,2,3,4,5] } }, { extend: 'excelHtml5', text: '<img src="images/microsoft_excel_logo.png" height="25"> Excel', titleAttr: 'Excel', title: function(){ return 'DATAHUB - Webservice Data Export'; }, filename: function(){ var p_id = moment().format('YYYY-MM-DD HH.mm.ss'); return 'DATAHUB - Webservice Data Export - ' + p_id; }, exportOptions: { // Fields to export (https://datatables.net/reference/button/csv#Examples) columns: [0,1,2,3,4,5] } }, { extend: 'pdfHtml5', text: '<img src="images/pdf_logo.png" height="25"> PDF', titleAttr: 'PDF', orientation: 'landscape', title: 'DATAHUB - Webservice Data Export - PDF', filename: function(){ var p_id = moment().format('YYYY-MM-DD HH.mm.ss'); return 'DATAHUB - Webservice Data Export - PDF - ' + p_id; }, exportOptions: { // Fields to export (https://datatables.net/reference/button/csv#Examples) columns: [0,1,2,3,4,5], modifier: { page: 'all' } } } ] }, bottomEnd: { paging: { buttons: 7, firstLast: true, boundaryNumbers: true } } }, language: { "decimal": ",", "thousands": ".", "emptyTable": "<?php echo $datahub_datatable_emptyTable ?>", "info": "<?php echo $datahub_datatable_Info ?>", "infoEmpty": "<?php echo $datahub_datatable_InfoEmpty ?>", "InfoFiltered": "<?php echo $datahub_datatable_InfoFiltered ?>", "infoPostFix": "", "lengthMenu": "<?php echo $datahub_datatable_LengthMenu ?>", "loadingRecords": "", "processing": "<?php echo $datahub_datatable_Processing ?>", "search": "<?php echo $datahub_datatable_Search ?>", "zeroRecords": "<?php echo $datahub_datatable_ZeroRecords ?>", "paginate": { "first": "<?php echo $datahub_datatable_First ?>", "last": "<?php echo $datahub_datatable_Last ?>", "next": "<?php echo $datahub_datatable_Next ?>", "previous": "<?php echo $datahub_datatable_Previous ?>" }, "aria": { "orderable": "Order by this column", "orderableReverse": "Reverse order this column" } }, "rowCallback": function(row, data, index) { }, "preDrawCallback": function(settings) { }, "initComplete": function () { } }); //============================================================================= // Setup the data to be able to update the table without reloading from the server //============================================================================= // Save the table in a global variable thisGlobalTableData = $('#REEFTvisual_data').DataTable(); // Handle click on "Edit" button $('#REEFTvisual_data tbody').on('click', '.edit-btn', function() { thisCurrentRow = $(this).closest('tr'); thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data(); // Debug // console.log("edit"); // console.log(thisGlobalRowData); //console.log(thisCurrentRow); dataChange(); }); // Handle click on "Delete" button $('#REEFTvisual_data tbody').on('click', '.delete-btn', function() { thisCurrentRow = $(this).closest('tr'); thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data(); // Debug // console.log(thisGlobalRowData); // console.log(thisCurrentRow); dataDeleteConfirm(); }); // Handle click on "Show transactions" button $('#REEFTvisual_data tbody').on('click', '.show-trans-btn', function() { thisCurrentRow = $(this).closest('tr'); thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data(); showTranscations( thisGlobalRowData.HUB_WEBNAM ); }); // Handle click on "Show char transactions" button $('#REEFTvisual_data tbody').on('click', '.show-chart-trans-btn', function() { thisCurrentRow = $(this).closest('tr'); thisGlobalRowData = thisGlobalTableData.row(thisCurrentRow).data(); showChartTransactions( thisGlobalRowData.HUB_WEBNAM ); }); //============================================================================= //============================================================================= // Place curor in search field - the wrapper id is provided by datatables - debug it! //============================================================================= $('#REEFTvisual_data_wrapper div.dt-search .dt-input').focus(); //============================================================================= } //============================================================================= // Reason addd -- not used //============================================================================= function dataAdd ( input_pk_type ) { var myHUB_WEBNAM = $('#input-HUB_SERTYP').val(); resetModalInputFields(); setModalInputDefaultFields(); $('#input-mode').val('*add'); // Reset save field save_HUB_WEBNAM = ''; save_HUB_SERTYP = ''; // Show on chart (default to Y) if ( HUB_SHWCHT.trim() == '' ) { set_YES_NO_Button('Y','HUB_SHWCHT','value') } // Set HUB_LSTCAL - default YES $('#button-deleted-yes').removeClass('btn-primary').addClass('btn-success'); $('#button-deleted-no').removeClass('btn-success').addClass('btn-primary'); // Reset modal message resetModalMessage(); // Remove key fields readonly $('#modal-input-HUB_WEBNAM').removeAttr('readonly','readonly'); $('#data-result-button-group-modal').removeClass('d-none'); // Show modal $('#hub_webcnt_maintainModal').modal('show'); $('#hub_webcnt_maintainModal').on('shown.bs.modal', function () { $('#modal-input-HUB_WEBNAM').trigger('focus'); }) } //============================================================================= // Show details //============================================================================= function dataChange( ) { var row = thisGlobalRowData; // Save in fields var HUB_WEBNAM = row["HUB_WEBNAM"]; var HUB_LSTCAL = row["HUB_LSTCAL"]; var HUB_DESCP1 = row["HUB_DESCP1"]; var HUB_DESCP2 = row["HUB_DESCP2"]; var HUB_COUNT = row["HUB_COUNT"]; var HUB_SERTYP = row["HUB_SERTYP"]; var HUB_CHRCOL = row["HUB_CHRCOL"]; var HUB_CHRTXT = row["HUB_CHRTXT"]; var HUB_CHRMIN = row["HUB_CHRMIN"]; var HUB_CHRMAX = row["HUB_CHRMAX"]; var HUB_DBGVAL = row["HUB_DBGVAL"]; var HUB_SHWCHT = row["HUB_SHWCHT"]; var counter = row["counter"]; $('#input-mode').val('*update'); save_HUB_WEBNAM = HUB_WEBNAM; // Move to input fields $('#modal-input-counter').val(counter); $('#modal-input-HUB_WEBNAM').val( HUB_WEBNAM ); $('#modal-input-HUB_LSTCAL').val( HUB_LSTCAL ); $('#modal-input-HUB_DESCP1').val( HUB_DESCP1 ); $('#modal-input-HUB_DESCP2').val( HUB_DESCP2 ); $('#modal-input-HUB_SERTYP').val( HUB_SERTYP ); $('#modal-input-HUB_COUNT').val( HUB_COUNT ); $('#modal-input-HUB_CHRTXT').val( HUB_CHRTXT ); $('#modal-input-HUB_CHRMIN').val( HUB_CHRMIN ); $('#modal-input-HUB_CHRMAX').val( HUB_CHRMAX ); $('#modal-input-HUB_DBGVAL').val( HUB_DBGVAL ); $('#modal-input-HUB_SHWCHT').val( HUB_SHWCHT ); // Make key fields readonly $('#modal-input-HUB_WEBNAM').attr('readonly','readonly'); $('#data-result-button-group-modal').removeClass('d-none'); // Set show on chart (default to Y) if ( HUB_SHWCHT.trim() == '' ) { set_YES_NO_Button('Y','HUB_SHWCHT','value') } else { set_YES_NO_Button(HUB_SHWCHT,'HUB_SHWCHT','value') } // Set color if ( HUB_CHRCOL == '' ) { HUB_CHRCOL = '#0000ff' } if ( HUB_CHRCOL == '#000000' ) { HUB_CHRCOL = '#0000ff' } //alert(HUB_CHRCOL) $('#modal-input-HUB_CHRCOL').spectrum("set", '#' + HUB_CHRCOL ); $('.read-only-class').attr('readonly','readonly'); // Reset modal message resetModalMessage(); // Show modal $('#hub_webcnt_maintainModal').modal('show'); $('#hub_webcnt_maintainModal').on('shown.bs.modal', function () { $('#modal-input-HUB_SERTYP').trigger('focus'); }) } //============================================================================= // Save //============================================================================= function dataSave() { // Reset modal message resetModalMessage(); // Check content of fields if ( $('#modal-input-HUB_WEBNAM').val() == '' ) { $('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0082 ?>' ); $('#modal-save-button').addClass('disabled').prop("disabled", true); $('#modal-input-HUB_WEBNAM').trigger('focus'); return false; } // if ( $('#modal-input-HUB_DESCP2').val() == '' ) { // $('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0085 ?>' ); // $('#modal-save-button').addClass('disabled').prop("disabled", true); // $('#modal-input-HUB_DESCP2').trigger('focus'); // return false; // } if ( $('#modal-input-HUB_DESCP1').val() == '' ) { $('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0084 ?>' ); $('#modal-save-button').addClass('disabled').prop("disabled", true); $('#modal-input-HUB_DESCP1').trigger('focus'); return false; } if ( $('#modal-input-HUB_SERTYP').val() == '' ) { $('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0086 ?>' ); $('#modal-save-button').addClass('disabled').prop("disabled", true); $('#modal-input-HUB_SERTYP').trigger('focus'); return false; } // if ( $('#modal-input-HUB_COUNT').val() == '' ) { // $('#modal-message').addClass('border-bottom').html( '<?php echo $datahub_error0083 ?>' ); // $('#modal-save-button').addClass('disabled').prop("disabled", true); // $('#modal-input-HUB_COUNT').trigger('focus'); // return false; // } var mode = $('#input-mode').val(); //=============================================================================== // Remove # if any //=============================================================================== // Setup remove string let mySaveString; // var myWorkField = $('#modal-input-DESCP1').val(); // myWorkField = myWorkField.replace("#", ""); // $('#modal-input-DESCP1').val( myWorkField ); // var myWorkField = $('#modal-input-DESCP2').val(); // myWorkField = myWorkField.replace("#", ""); // $('#modal-input-DESCP2').val( myWorkField ); var myWorkField = $('#modal-input-HUB_CHRMIN').val(); myWorkField = myWorkField.replace(",", "."); myWorkField = parseFloat(myWorkField).toFixed(3).toString(); $('#modal-input-CHRMIN').val( myWorkField ); var myWorkField = $('#modal-input-HUB_CHRMAX').val(); myWorkField = myWorkField.replace(",", "."); myWorkField = parseFloat(myWorkField).toFixed(3).toString(); $('#modal-input-CHRMAX').val( myWorkField ); var myWorkField = $('#modal-input-HUB_DBGVAL').val(); myWorkField = myWorkField.replace(",", "."); myWorkField = parseFloat(myWorkField).toFixed(0).toString(); $('#modal-input-DBGVAL').val( myWorkField ); //=============================================================================== // Make sure key does not have space and are in uppercase // var myWorkField = $('#modal-input-HUB_WEBNAM').val(); // myWorkField = myWorkField.replace(" ", "_"); // myWorkField = myWorkField.toUpperCase(); // $('#modal-input-HUB_WEBNAM').val( myWorkField ); // Make array and json var myData = $('#dataForm').find('input, select, textarea').serializeArray(); var result = JSON.stringify(myData); var result = encodeURIComponent( result ); // console.log(result); // console.log(myData); // return; var parmData = 'data=' + result + '&mode=' + mode ; $.ajax({ url: "hub_webcnt_maintain_save.php", type: "POST", data: parmData, dataType: "json", cache: false, }) .done(function( jsonData ) { //================================================================= // START - Update the table without doing a server reload // Only update //================================================================= if ( mode == '*update' ) { event.preventDefault(); // Debug // console.log(myGlobalRowData[0]); // console.log(myGlobalRowData[1]); // console.log(myGlobalRowData[2]); // console.log(myCurrentRow); // console.table(myGlobalTableData); // Get the data for the "Change/Delete button", so we do not need to create it again // myChangeButtonData = myGlobalRowData[6]; // myDeleteButtonData = myGlobalRowData[7]; //============================================== // Use this if you want to update the whole row //============================================== // myGlobalTableData.row(myCurrentRow).data([ // modal_input_HUB_WEBNAM, // modal_input_LSTCAL, // modal_input_DESCP1, // modal_input_DESCP2, // modal_input_COUNT, // modal_input_SERTYP, // myChangeButtonData, // myDeleteButtonData, // modal_input_DESCP1, // modal_input_DESCP2 // ]) // .draw(false) // ; //======================================================= // Use this if you want to update one or more table cells //======================================================= thisGlobalTableData.cell(thisCurrentRow, 0 ).data( $('#modal-input-HUB_WEBNAM').val() ); thisGlobalTableData.cell(thisCurrentRow, 1 ).data( $('#modal-input-HUB_LSTCAL').val() ); thisGlobalTableData.cell(thisCurrentRow, 2 ).data( $('#modal-input-HUB_DESCP1').val() + '<br>' + $('#modal-input-HUB_DESCP2').val() ); thisGlobalTableData.cell(thisCurrentRow, 3 ).data( $('#modal-input-HUB_COUNT').val() ); thisGlobalTableData.cell(thisCurrentRow, 4 ).data( $('#modal-input-HUB_SERTYP').val() ); thisGlobalTableData.cell(thisCurrentRow, 6 ).data( $('#modal-input-HUB_CHRTXT').val() ); thisGlobalTableData.cell(thisCurrentRow, 7 ).data( $('#modal-input-HUB_CHRMIN').val() ); thisGlobalTableData.cell(thisCurrentRow, 8 ).data( $('#modal-input-HUB_CHRMAX').val() ); // 9 = Show on chart Y/N // 10 = Edit button // 11 = Delete button // 12 = Transactions // 13 = Chart thisGlobalTableData.cell(thisCurrentRow, 14 ).data( $('#modal-input-HUB_DBGVAL').val() ); thisGlobalTableData.cell(thisCurrentRow, 15 ).data( $('#modal-input-HUB_DESCP1').val() ); thisGlobalTableData.cell(thisCurrentRow, 16 ).data( $('#modal-input-HUB_DESCP2').val() ); thisGlobalTableData.cell(thisCurrentRow, 17 ).data( $('#modal-input-HUB_CHRCOL').val() ); thisGlobalTableData.cell(thisCurrentRow, 18 ).data( $('#modal-input-HUB_SHWCHT').val() ); //.draw(false); // Show new color var HUB_CHRCOL_TEXT = '<div style="display:block;margin:auto;width:25px;height:25px; background-color:' + $('#modal-input-HUB_CHRCOL').val() + '"> </div>'; thisGlobalTableData.cell(thisCurrentRow, 5 ).data( HUB_CHRCOL_TEXT ); //thisGlobalTableData.cell(thisCurrentRow, 5 ).data( HUB_CHRCOL_TEXT ).draw(false); if ( $('#modal-input-HUB_SHWCHT').val() == 'N' ) { HUB_SHWCHT_text = '<?php echo $datahub_NO ?>'; } else { HUB_SHWCHT_text = '<?php echo $datahub_YES ?>'; } thisGlobalTableData.cell(thisCurrentRow, 9 ).data( HUB_SHWCHT_text ); } //================================================================= // END - Update the table without doing a server reload //================================================================= //================================================================= // Close the modal //================================================================= $('#hub_webcnt_maintainModal').modal('hide'); //================================================================= // Only when add //================================================================= if ( mode == '*add' ) { var myButtonID = 'select-button-line-id-' + $('#input-HUB_SERTYP').val(); $('#' + myButtonID).click(); getData(''); } }) .always(function( jsonData ) { // Reset mode $('#input-mode').val(''); // Reset input fields resetModalInputFields(); }) .fail(function( xhr, ajaxOptions, thrownError ) { console.log('I am failed..'); console.log( thrownError ); console.log( xhr ); }); } //============================================================================= // Delete confirm //============================================================================= function dataDeleteConfirm( ) { $('#input-mode').val('*delete'); var row = thisGlobalRowData; var input_HUB_WEBNAM = row["HUB_WEBNAM"]; $('#confirm-delete-HUB_WEBNAM').val(input_HUB_WEBNAM); // Create confirm text $('#confirm-delete-text-HUB_WEBNAM').html(input_HUB_WEBNAM); $('#HUB_WEBCNT_confirmDeleteModal').modal('show'); } //============================================================================= // Delete //============================================================================= function dataDeleteExec() { // Reset modal message resetModalMessage(); var mode = $('#input-mode').val(); // Make array and json var myData = $('#dataForm-delete').find('input, select').serializeArray(); var result = JSON.stringify(myData); // console.log(result); // console.log(myData); //return; var parmData = 'data=' + result + '&mode=' + mode ; $.ajax({ url: "HUB_WEBCNT_maintain_save.php", type: "POST", data: parmData, dataType: "json", cache: false, }) .done(function( jsonData ) { $('#HUB_WEBCNT_confirmDeleteModal').modal('hide'); //================================================================= // Only when add //================================================================= if ( mode == '*delete' ) { var myButtonID = 'select-button-line-id-' + $('#input-HUB_SERTYP').val(); $('#' + myButtonID).click(); resetModalInputFields(); getData(''); } }) .always(function( jsonData ) { }) .fail(function( xhr, ajaxOptions, thrownError ) { console.log('I am failed..'); console.log( xhr ); }); } //============================================================================= // Check if userid exists //============================================================================= function checkDataExists() { return; var HUB_WEBNAM = $('#modal-input-HUB_WEBNAM').val(); // If update, then the "orginal" code is ok if ( $('#input-mode').val() == '*update' ) { if ( HUB_WEBNAM == save_HUB_WEBNAM ) { // return; } } var parmData = 'HUB_WEBNAM=' + HUB_WEBNAM ; $.ajax({ url: "hub_conchk_get.php", type: "GET", data: parmData, dataType: "json", cache: false, }) .done(function( jsonData ) { var returnCode = jsonData.header.returnCode; var returnMsg = jsonData.header.returnMsg; var entries_found = jsonData.header.entries_found; var returnConfigValue = jsonData.header.returnConfigValue; var returnConfigValueText = jsonData.header.returnConfigValueText; if ( returnConfigValue == '50') { $('#modal-message').addClass(' border-bottom').html( '<?php echo $datahub_error0087 ?>' ); $('#modal-save-button').addClass('disabled').prop("disabled", true); $('#modal-input-HUB_WEBNAM').trigger('focus'); return false; } else { // DESCP = jsonData.detail[0].DESCP // $('#modal-input-HUB_COUNT').val( DESCP ); } // Reset modal message resetModalMessage(); }) .always(function( jsonData ) { }) .fail(function( xhr, ajaxOptions, thrownError ) { console.log('I am failed..'); console.log( xhr ); }); } //============================================================================= // Show deleted //============================================================================= function showDeleted() { var show_deleted = $('#input-show-deleted').val(); if ( show_deleted == 'Y' ) { $('#button-show-deleted').html('<?php echo $datahub_NO ?>'); $('#input-show-deleted').val('N'); } else { $('#button-show-deleted').html('<?php echo $datahub_YES ?>'); $('#input-show-deleted').val('Y'); } } //============================================================================= // Set default modal input fields //============================================================================= function setModalInputDefaultFields() { var myHUB_WEBNAM = $('#input-HUB_SERTYP').val(); // $('#modal-input-HUB_LSTCAL').val('1'); // $('#modal-input-HUB_CHRCOL').val( $('#input-current-date').val() ); // $('#modal-input-HUB_CHRTXT').val( $('#input-current-time').val() ); } //============================================================================= // Reset modal input fields //============================================================================= function resetModalInputFields() { // $('#modal-input-HUB_LSTCAL').val(''); // $('#modal-input-HUB_DESCP1').val(''); // $('#modal-input-HUB_WEBNAM').val(''); // $('#modal-input-HUB_SERTYP').val(''); // $('#modal-input-HUB_COUNT').val(''); // $('#modal-input-HUB_DESCP2').val(''); // $('#modal-input-HUB_CHRCOL').val(''); // $('#modal-input-HUB_CHRCOL').val(''); // $('#modal-input-HUB_CHRTXT').val(''); $('#input-mode').val(''); } //============================================================================= // Log off //============================================================================= function signoff() { window.location.href = "logout.php"; } //============================================================================= // Load page //============================================================================= function loadPage(url, p1, p2, p3) { window.location.href = url; } //============================================================================= // Reset modal message //============================================================================= function resetModalMessage() { // Reset //$('#modal-message').removeClass('p-2 font-weight-bold border border-danger rounded bg-light').html( ' ' ); $('#modal-message').removeClass('border-bottom').html( ' ' ); $('#modal-save-button').removeClass('disabled').prop("disabled", false); } //============================================================================= // Clean input string //============================================================================= function cleanInputString( myWorkField ) { let charactersToRemove = '?#"\''; let myPattern = new RegExp('[' + charactersToRemove + ']', 'g'); myWorkField = myWorkField.replace(myPattern,''); return myWorkField; } //============================================================================= // Full screen popup //============================================================================= function popUpFull( url, p1, p2, p3 ) { var winname = 'win_' + url; params = 'width='+screen.width; params += ', height='+screen.height; params += ', top=0, left=0' params += ', fullscreen=yes'; params += ',scrollbars=1'; overview_win = window.open(url,winname, params); if (window.focus) {overview_win.trigger('focus')} return false; } //============================================================================= // screen popup - center //============================================================================= function popUpCenter(url, p1, p2, p3) { var v1_w = screen.availWidth; var v1_h = screen.availHeight; if ( parseInt(v1_w) > 1800 ) { v1_w = 1800; v1_h = v1_h - 200; v1_center = v1_w/0.8; } // Center popup as good as possible var left = (screen.width - v1_w) / 2; var top = (screen.height - v1_h) / 4; var winname = 'win_' + url; params = 'width='+v1_w; params += ', height='+v1_h; params += ', top=' + top + ', left=' + left; params += ', fullscreen=yes'; params += ',scrollbars=1'; overview_win = window.open(url,winname, params); if (window.focus) {overview_win.trigger('focus')} return false; } //============================================================================= // screen popup - center - bigger //============================================================================= function popUpCenterBig(url, p1, p2, p3) { var v1_w = screen.availWidth; var v1_h = screen.availHeight; // Get 25% v1_w_pct = v1_w * 0.25; v1_w_new = v1_w - v1_w_pct; if ( v1_w_new < 1 ) { v1_w_new = 1800; } v1_w = v1_w_new; v1_h = v1_h - 200; v1_center = v1_w/0.8; // Center popup as good as possible var left = (screen.width - v1_w) / 2; var top = (screen.height - v1_h) / 4; var winname = 'win_' + url; params = 'width='+v1_w; params += ', height='+v1_h; params += ', top=' + top + ', left=' + left; params += ', fullscreen=yes'; params += ',scrollbars=1'; overview_win2 = window.open(url, winname, params); if (overview_win2 && !overview_win2.closed) { overview_win2.focus(); } } //============================================================================= // Popup top //============================================================================= function popUpTop(url, p1, p2, p3) { var winname = 'win_' + url; w = 650; h = 750; params = 'width='+w; params += ', height='+h; params += ', top=0, left=0' params += ', fullscreen=no'; params += ',scrollbars=1'; overview_win = window.open(url,winname, params); if (window.focus) {overview_win.trigger('focus')} return false; } //============================================================================= // Clean input string //============================================================================= function cleanInputString( myWorkField ) { let charactersToRemove = '?#"\''; let myPattern = new RegExp('[' + charactersToRemove + ']', 'g'); myWorkField = myWorkField.replace(myPattern,''); return myWorkField; } //============================================================================= // Set config type //============================================================================= function setConfigType( inputType ) { outputType = inputType; if ( inputType == 'A' ) { var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_A; } if ( inputType == 'N' ) { var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_N; } if ( inputType == 'L' ) { var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_L; } if ( inputType == 'T' ) { var outputType = GLOBAL_CONFIG_TYPE_BUTTON_TEXT_T; } return outputType; } //============================================================================= // Create config type buttons //============================================================================= function createConfigTypeButtons() { } //============================================================================= // Select config type //============================================================================= function selectConfigType( inputType ) { $('#modal-input-HUB_COUNT').val( inputType ); // Remove all "active" marks $('.btn-config-type').removeClass('active btn-success').addClass('btn-primary');; // Mark button as selected myID = 'button-config_type-button-' + inputType; $('#' + myID ).addClass('active btn-success').removeClass('btn-primary'); } //============================================================================= // Select line modal //============================================================================= function selectGroupValueModal( inputLine ) { $('#modal-input-HUB_SERTYP').val( inputLine ); var selectButtonLineID = 'select-button-line-id-modal-' + inputLine; $('.select-button-line-modal').removeClass('btn-success').addClass('btn-primary'); $('#' + selectButtonLineID).removeClass('btn-primary').addClass('btn-success'); // Place cursor $('#modal-input-HUB_WEBNAM').trigger('focus'); resetModalMessage(); } //============================================================================= // Reset line modal //============================================================================= function resetLineModal() { resetModalMessage() let inputLine = $('#modal-input-HUB_WEBNAM').val(); if ( inputLine == '' ) { $('.select-button-line-modal').removeClass('btn-success').addClass('btn-primary'); } } //============================================================================= // Set action type //============================================================================= function setActionType( inputType ) { outputType = ''; if ( inputType == '*PDF' ) { outputType = '1'; } if ( inputType == '*PIC' ) { outputType = '2'; } if ( inputType == '*SCAN' ) { outputType = '3'; } if ( inputType == '*MOVIE' ) { outputType = '4'; } if ( inputType == '*LINK' ) { outputType = '5'; } if ( inputType == '*CHECK' ) { outputType = '6'; } return outputType; } //============================================================================= // Open previewer //============================================================================= function preViewElement( myElement ) { let h = $(window).height(); let w = $(window).width(); console.log('h: ' + h + ' -- ' + 'w: ' + w); h = h * 0.75; console.log('h: ' + h + ' -- ' + 'w: ' + w); // Create ID let myID = '#' + myElement; let myURL = $( myID ).val(); let myIFRAME = '<iframe style="height:' + h + 'px;width:100%;" src=' + myURL +'></iframe>'; // Set iframe $('#modal-preview-iframe').html( myIFRAME ); // Show modal $('#HUB_WEBCNT_previewModal').modal('show'); } //============================================================================= // Show transcations //============================================================================= function showTranscations( HUB_WEBNAM ) { var url = 'hub_webtrn_maintain.php'; var p1 = ''; var p2 = 'new-tab'; var p3 = ''; url = url + '?webnam=' + HUB_WEBNAM; popUpCenterBig(url, p1, p2, p3); } //============================================================================= // Show chart - transactions //============================================================================= function showChartTransactions ( HUB_WEBNAM ) { var url = 'hub_webtrn_chart.php'; var p1 = ''; var p2 = ''; var p3 = ''; var win_type = 'new-tab'; url = url + '?hub_webnam=' + HUB_WEBNAM; popUpCenterBig(url, p1, p2, p3); } //============================================================================= // Show chart //============================================================================= function showChart() { // Get prveious search var url = 'hub_webcnt_chart.php'; var p1 = ''; var p2 = 'new-tab'; var p3 = $('#input-prv-searchBy').val(); popUpCenterBig(url, p1, p2, p3); } //============================================================================= // Get data - search //============================================================================= function setWebserviceSearch( input_HUB_SERTYP ) { // Save curreent webservice name $('#input-HUB_SERTYP').val( input_HUB_SERTYP ); var selectButtonLineID = 'select-button-line-id-' + input_HUB_SERTYP; // Set clicked button $('.select-button-line').removeClass('btn-success').addClass('btn-dark'); $('#' + selectButtonLineID).removeClass('btn-dark').addClass('btn-success'); // Search - destory table and start over again //$('#REEFTvisual_data').DataTable().clear().destroy(); $('#REEFTvisual_data').DataTable().clear().draw(); //getData(); //setDataTables(); } //============================================================================= // Set Yes/No button //============================================================================= function set_YES_NO_Button( inputValue, inputID, inputType ) { // Bool if ( inputType == 'bool' ) { if (inputValue == '') { inputValue = '0'; } } // Value if ( inputType == 'value' ) { if (inputValue == '') { inputValue = 'N'; } } var yesID = 'button-yes-' + inputID; var noID = 'button-no-' + inputID; var thisID = 'modal-input-' + inputID; if ( inputType == 'bool' ) { if ( inputValue == '1' ) { $('#' + yesID).removeClass('btn-primary').addClass('btn-success'); $('#' + noID).removeClass('btn-success').addClass('btn-primary'); } else { $('#' + yesID).removeClass('btn-success').addClass('btn-primary'); $('#' + noID).removeClass('btn-primary').addClass('btn-success'); } } if ( inputType == 'value' ) { if ( inputValue == 'Y' ) { $('#' + yesID).removeClass('btn-primary').addClass('btn-success'); $('#' + noID).removeClass('btn-success').addClass('btn-primary'); } else { $('#' + yesID).removeClass('btn-success').addClass('btn-primary'); $('#' + noID).removeClass('btn-primary').addClass('btn-success'); } } // Set value for input field $('#' + thisID).val(inputValue); } //============================================================================= // Close modal //============================================================================= function closeModal() { $('#hub_webcnt_maintainModal').modal('hide'); } //============================================================================= // Set clock //============================================================================= function updateClock() { var currentTime = moment().format('YYYY-MM-DD HH:mm:ss'); currentTime = REEFT_format_date( currentTime, DFT_DATE_DISPLAY_FORMAT ) $('#input-current-date').val( moment().format('YYYY-MM-DD') ); $('#input-current-time').val( moment().format('HH:mm:ss') ); $('#current-time').html( currentTime ); // If add mode update date/time in modal window if ( $('#input-mode').val() == '*add' ) { $('#modal-input-HUB_CHRCOL').val( $('#input-current-date').val() ); $('#modal-input-HUB_CHRTXT').val( $('#input-current-time').val() ); } } //============================================================================= // jQuery - Ready //============================================================================= $(document).ready(function() { // When closing modal $('#hub_webcnt_maintainModal').on('hidden.bs.modal', function (e) { resetModalInputFields(); }) // Do not show deleted $('#input-show-deleted').val('Y'); $('#input-HUB_SERTYP').val('<?php echo $HUB_SERTYP ?>'); // Get data done by datatables setDataTables(); $('#delay-marker-id').html('<i id="delay-marker-icon-id" class="text-success fa-solid fa-circle"></i>'); //----------------------------------------------------------------------- // Start the clock //----------------------------------------------------------------------- updateClock(); setInterval(function() { updateClock(); }, 1000); //----------------------------------------------------------------------- //----------------------------------------------------------------------- // Set font awesome icon type //----------------------------------------------------------------------- // Value is from config/config.php var iconType = '<?php echo $DFT_SET_FONT_AWESOME_ICON_TYPE ?>'; setFontAwesomeIconType( iconType ); //----------------------------------------------------------------------- //----------------------------------------------------------------------- // Delay keyup checker //----------------------------------------------------------------------- var delay = (function () { var timer = 0; return function (callback, ms) { clearTimeout(timer); timer = setTimeout(callback, ms); }; })() // DataTable search delay $('#REEFTvisual_data_wrapper .dataTables_filter input') .unbind() // overrule normal behavior .bind('keyup', function(e){ $('#delay-marker-icon-id').removeClass('text-success').addClass('text-danger'); var inputValue = $('.dataTables_filter input').val(); var currSearchValue = $('#input-search-line').val(); if (inputValue != currSearchValue) { $('#input-search-line').val( inputValue ); //If enter or delete we update immediately, consider to add backspace=8 and delete=46 also const keyList = [13]; if (keyList.includes(e.keyCode)) { // console.log('immediately ' + inputValue ); $('#delay-marker-icon-id').removeClass('text-danger').addClass('text-success'); thisGlobalTableData.search(inputValue).draw(); // fire in the hole } else { delay(function () { // console.log('this will hit, once user has not typed for 1 second ' + inputValue ); $('#delay-marker-icon-id').removeClass('text-danger').addClass('text-success'); thisGlobalTableData.search(inputValue).draw(); // fire in the hole }, 0800); } } }); //========================================================================================================= // Set color picker - TEXT // // Create HEX value (https://en.wikipedia.org/wiki/Web_colors) // var hexValueColor = color.toHexString(); // // Create RGB (https://en.wikipedia.org/wiki/RGB_color_model) // hexcolor = hexcolor.replace("#", ""); // var r = parseInt(hexcolor.substr(0,2),16); // var g = parseInt(hexcolor.substr(2,2),16); // var b = parseInt(hexcolor.substr(4,2),16); // var yiq = ((r*299)+(g*587)+(b*114))/1000; // // // Create YIQ (https://en.wikipedia.org/wiki/YIQ) // if ( yiq >= 128) { // var textColor = 'black'; // } else { // var textColor = 'white'; // } // // console.log('change: ' + hexcolor + ' ' + hexValueColor + ' ' + yiq + ' ' + r + ' ' + g + ' ' + b ); // //========================================================================================================= $(".text-color-palette").spectrum({ showInitial: true, showInput: true, chooseText: "Vælg farve", cancelText: "Annuller", preferredFormat: "hex", color: "#000", showPalette: true, flat: false, palette: [ ["#000","#444","#666","#999","#ccc","#eee","#f3f3f3","#fff"], ["#f00","#f90","#ff0","#0f0","#0ff","#00f","#90f","#f0f"], ["#f4cccc","#fce5cd","#fff2cc","#d9ead3","#d0e0e3","#cfe2f3","#d9d2e9","#ead1dc"], ["#ea9999","#f9cb9c","#ffe599","#b6d7a8","#a2c4c9","#9fc5e8","#b4a7d6","#d5a6bd"], ["#e06666","#f6b26b","#ffd966","#93c47d","#76a5af","#6fa8dc","#8e7cc3","#c27ba0"], ["#c00","#e69138","#f1c232","#6aa84f","#45818e","#3d85c6","#674ea7","#a64d79"], ["#900","#b45f06","#bf9000","#38761d","#134f5c","#0b5394","#351c75","#741b47"], ["#600","#783f04","#7f6000","#274e13","#0c343d","#073763","#20124d","#4c1130"] ], // Called as the original input changes. Only happens when the input is closed or the 'Choose' button is clicked. change: function(color) { // Get hex color var hexValueColor = color.toHexString(); }, move: function(color) { // Get hex color var hexValueColor = color.toHexString(); }, show: function(color) { $('#input-current-color-picker').val( this.id ); // Get hex color var hexValueColor = color.toHexString(); }, hide: function(color) { // Get hex color var hexValueColor = color.toHexString(); } }); //----------------------------------------------------------------------- // Check exists //----------------------------------------------------------------------- let $filter01 = $('#modal-input-HUB_WEBNAM'); $filter01.on('keyup', function () { delay(function () { var inputValue = $('#modal-input-HUB_WEBNAM').val(); if ( inputValue != '') { console.log('this will hit, once user has not typed for 1 second ' + inputValue ); checkDataExists(); } }, 0800); }); //----------------------------------------------------------------------- // Event listener for the update button //----------------------------------------------------------------------- $('#updateButton').on('click', function() { // Trigger a redraw of the table thisGlobalTableData.draw(); }); //----------------------------------------------------------------------- // Set short cuts //----------------------------------------------------------------------- // If add d-none class, do not add shortcut if ( GLOBAL_ADD_ALLOWED == 'Y' ) { shortcut.add("Alt+F6",function() { $('#add-button').click(); }); // Show add button $('#add-button').removeClass('d-none'); } // // Close window // shortcut.add("Shift+Esc",function() { // $('#button-close').click(); // }); }); // --> </script> </head> <body> <div class="container-fluid mt-2 pl-3 pr-3"> <input type="text" class="d-none" id="input-HUB_SERTYP"> <input type="text" class="d-none" id="input_search"> <input type="text" class="d-none" id="input-mode"> <input type="text" class="d-none" id="input-current-date"> <input type="text" class="d-none" id="input-current-time"> <input type="text" class="d-none" id="input-show-deleted" > <input type="text" class="d-none" id="input-search-line"> <input type="text" class="d-none" id="input-filter-line"> <input type="text" class="d-none" id="input-rpyOffSet"> <input type="text" class="d-none" id="input-rpyTotalRecordsFound"> <input type="text" class="d-none" id="input-rpyTotalPages"> <input type="text" class="d-none" id="input-rpyPageSize"> <div class="row"> <div class="col-2"> <img src="images/customer-logo.png" alt="Customer Logo"> </div> <div class="col-8 text-center <?php echo $DFT_CLOCK_SIZE ?>"> <i class="font-awesome-pseudo-class fa-thin fa-clock"></i> <span id="current-time"><?php echo date('d-m-Y h:i:s') ?></span> </div> <div class="col-2 text-right"> <div class="btn btn-primary mb-1" onclick="loadPage('menu_admin.php','','','')" title="<?php echo $datahub_go_to_my_dear_home ?>"><i class="font-awesome-pseudo-class fa-2x fa-thin fa-home"></i></div> <div class="d-none"> <div class="btn btn-primary mb-1 d-none d-xl-inline-block" onclick="loadPage('menu_main.php','','','')" title="<?php echo $datahub_go_to_my_dear_home_03 ?>"><i class="font-awesome-pseudo-class fa-2x fa-thin fa-fort"></i></div> <div class="btn btn-danger mb-1 d-none d-lg-inline-block" onclick="signoff()" title="<?php echo $datahub_go_to_my_dear_home_02 ?>"><i class="font-awesome-pseudo-class fa-thin fa-2x fa-right-from-bracket"></i></div> </div> </div> </div> <div class="row"> <div class="col-12 text-center"> <div id="data-hub-company-information"></div> </div> </div> <div class="card mt-2"> <div class="card-header text-muted"> <div class="row mt-2"> <div class="col-4 h4"> <i class="font-awesome-pseudo-class fa-thin fa-alicorn"></i> <?php echo "$datahub_text0142"; ?> </div> <div class="col-4 text-center"> <span title="Show as chart" onclick="showChart()" style="cursor: pointer;"><i class="fa-duotone fa-4x fa-solid fa-chart-mixed" style="--fa-primary-color: orange; --fa-secondary-color: forestgreen; --fa-secondary-opacity: 0.7;"></i></span> <br> <span onclick="showChart()" style="cursor: pointer;">Show chart</span> </div> <div class="col-4 text-right font-weight-bold"> <div class="row"> <div class="col text-right d-none"> <?php echo $datahub_text0059 ?> <span id="text-current-page">...</span> <?php echo $datahub_text0060 ?> <span id="text-total-pages">...</span> </div> </div> <div class="row"> <div class="col text-right"> <?php echo $datahub_text0061 ?> : <span id="text-total-records-found">...</span> </div> </div> </div> </div> </div> <div class="card-body"> <!-- Message if screen is not wide enough --> <div class="container-fluid mt-2 mb-4 d-block d-lg-none"> <div id="general-message-top" class="border border-danger rounded p-2 text-danger font-weight-boldx"><?php echo $datahub_error0040a ?></div> </div> <!-- Message if screen is not wide enough --> <!-- Group lines found --> <div class="d-none d-lg-block"> <div class="row mb-2"> <div class="col-12"> <div id="data-result-button-group"></div> </div> </div> </div> <div class="row mt-2"> <div class="col-12"> <table id="REEFTvisual_data" class="table table-bordered table-striped table-hover"> <thead> <tr class="bg-primary text-white font-weight-bold text-center"> <th class="text-left"><?php echo $datahub_text0140 ?></th> <th class="text-left"><?php echo "$datahub_text0149 ($datahub_text0145)" ?></th> <th class="text-left"><?php echo $datahub_text0146 ?> 1</th> <th class="text-left"><?php echo $datahub_text0147 ?></th> <th class="text-left"><?php echo $datahub_text0148 ?></th> <th class="text-left"><?php echo $datahub_text0216 ?></th> <th class="text-left"><?php echo $datahub_text0217 ?></th> <th class="text-left"><?php echo $datahub_text0219a?></th> <th class="text-left"><?php echo $datahub_text0220a?></th> <th class="text-left"><?php echo $datahub_text0225a?></th> <th class="text-left"><button type="button" id="add-button" title="Shortcut: Alt+F6" onclick="dataAdd('0')" class="d-none btn btn-dark btn-block font-weight-bold"><?php echo $datahub_button_save_01 ?></button></th> <th class="text-left"></th> <th class="text-left"></th> <th class="text-left"></th> <th class="text-left">HUB_DBGVAL</th> <th class="text-left">HUB_DESCP1</th> <th class="text-left">HUB_DESCP2</th> <th class="text-left">HUB_CHRCOL</th> <th class="text-left">HUB_SHWCHT</th> </tr> </thead> </table> </div> </div> <div class="row"> <div class="col text-right mb-2"> <small><div id="load-time-from-database"></div></small> </div> </div> </div> </div> </div> <!-- Set footer --> <?php include "include/footer.php"; ?> <!-- Set footer --> <!-- ========================================================================== --> <!-- M O D A L S --> <!-- ========================================================================== --> <!-- Modal --> <div class="modal fade" id="hub_webcnt_maintainModal" tabindex="-1" data-backdrop="static" role="dialog" aria-labelledby="hub_webcnt_maintainModalLabel" aria-hidden="true"> <div class="modal-dialog modal-xxl"> <div class="modal-content"> <div class="modal-header bg-primary text-white"> <div class="container-fluid pl-0 pr-0"> <div class="row"> <div class="col-8"> <h5 class="modal-title" id="hub_webcnt_maintainModalLabel"><i class="font-awesome-pseudo-class fa-thin fa-alicorn"></i> <?php echo $datahub_text0142 ?></h5> </div> <div class="col text-right"> </div> <div class="col-1 text-right" style="max-width:20px"> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> </div> </div> </div> <div class="modal-body ml-2 mr-2"> <input type="text" class="d-none" id="input-current-color-picker"> <input type="text" class="d-none" id="input-current-text-color"> <input type="text" class="d-none" id="input-current-background-color"> <!-- Message if screen is not wide enough --> <div class="container-fluid mt-2 mb-4 d-block d-lg-none"> <div id="general-message-top" class="border border-danger rounded p-2 text-danger font-weight-boldx"><?php echo $datahub_error0040a ?></div> </div> <!-- Message if screen is not wide enough --> <form name="dataForm" id="dataForm"> <!-- Hidden fields start --> <!-- Hidden fields end --> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0140 ?> </div> <div class="col-3"> <input class="form-control read-only-class" type="text" id="modal-input-HUB_WEBNAM" maxlength="50" name="modal-input-HUB_WEBNAM"> </div> </div> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0149 ?> </div> <div class="col-3"> <input class="form-control read-only-class" type="text" id="modal-input-HUB_LSTCAL" name="modal-input-HUB_LSTCAL"> </div> </div> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0147 ?> </div> <div class="col-2"> <input class="form-control read-only-class" type="text" id="modal-input-HUB_COUNT" name="modal-input-HUB_COUNT"> </div> </div> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0146 ?> 1 </div> <div class="col-6"> <textarea class="form-control" id="modal-input-HUB_DESCP1" name="modal-input-HUB_DESCP1" rows="2" onkeyup="resetModalMessage()"></textarea> </div> </div> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0146 ?> 2 </div> <div class="col-6"> <textarea class="form-control" id="modal-input-HUB_DESCP2" name="modal-input-HUB_DESCP2" rows="2" onkeyup="resetModalMessage()"></textarea> </div> </div> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0148 ?> </div> <div class="col-2"> <input class="form-control" type="text" id="modal-input-HUB_SERTYP" name="modal-input-HUB_SERTYP"> </div> <div class="col-6"> <div id="data-result-button-group-modal"></div> </div> </div> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0216 ?> </div> <div class="col-2"> <input class="text-color-palette form-control" type="text" id="modal-input-HUB_CHRCOL" name="modal-input-HUB_CHRCOL"> </div> </div> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0217 ?> </div> <div class="col-2"> <input class="form-control" type="text" id="modal-input-HUB_CHRTXT" name="modal-input-HUB_CHRTXT"> </div> </div> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0219 ?> </div> <div class="col-2"> <input class="form-control" type="text" id="modal-input-HUB_CHRMIN" name="modal-input-HUB_CHRMIN"> </div> </div> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0220 ?> </div> <div class="col-2"> <input class="form-control" type="text" id="modal-input-HUB_CHRMAX" name="modal-input-HUB_CHRMAX"> </div> </div> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0224 ?> </div> <div class="col-2"> <input class="form-control" type="text" id="modal-input-HUB_DBGVAL" name="modal-input-HUB_DBGVAL"> </div> </div> <div class="row mt-2"> <div class="col-3"> <?php echo $datahub_text0225 ?> </div> <div class="col-2"> <button type="button" onclick="set_YES_NO_Button('Y','HUB_SHWCHT','value')" class="btn btn-primary" id="button-yes-HUB_SHWCHT"><?php echo $datahub_YES ?></button> <button type="button" onclick="set_YES_NO_Button('N','HUB_SHWCHT','value')" class="btn btn-primary" id="button-no-HUB_SHWCHT"><?php echo $datahub_NO ?></button> <input class="form-control d-none" type="text" id="modal-input-HUB_SHWCHT" name="modal-input-HUB_SHWCHT"> </div> </div> </form> </div> <div class="modal-footer-pretty modal-footer"> <div class="container-fluid"> <div class="row"> <div class="col-12 text-left"> <div class="p-1 font-weight-bold text-danger border-top border-dark " id="modal-message"> </div> </div> </div> <div class="row mt-1 mb-2"> <div class="col-3 text-left"> <button type="button" id="modal-save-button" class="btn btn-primary btn-block" onclick="dataSave()"><?php echo $datahub_button_save ?></button> </div> <div class="col-6 text-right"> </div> <div class="col-3 text-right"> <button type="button" class="btn btn-primary btn-block" data-dismiss="modal"><?php echo $datahub_button_cancel_01 ?></button> </div> </div> </div> </div> </div> </div> </div> <!-- ************************************************ --> <!-- Confirm delete --> <!-- ************************************************ --> <div class="modal fade" id="HUB_WEBCNT_confirmDeleteModal" tabindex="-1" role="dialog" aria-labelledby="HUB_WEBCNT_confirmDeleteModalLabel" aria-hidden="true"> <div class="modal-dialog modal-xl" role="document"> <div class="modal-content"> <div class="modal-header bg-primary text-white"> <h5 class="modal-title" id="HUB_WEBCNT_confirmDeleteModalLabel"><?php echo $datahub_text0063 ?></h5> <button type="button" class="close" data-dismiss="modal" aria-label="Close"> <span aria-hidden="true">×</span> </button> </div> <div class="modal-body"> <form name="dataForm-delete" id="dataForm-delete"> <input type="text" class="d-none" id="confirm-delete-HUB_WEBNAM" name="confirm-delete-HUB_WEBNAM"> </form> <div class="h6"><?php echo $datahub_text0062 ?>: <span class="font-weight-bold" id="confirm-delete-text-HUB_WEBNAM"></span></div> </div> <div class="modal-footer"> <div class="container-fluid"> <div class="row mt-1 mb-2"> <div class="col-3 text-left"> <button type="button" onclick="dataDeleteExec()" class="btn btn-primary"><?php echo $datahub_button_delete ?></button> </div> <div class="col-6 text-right"> </div> <div class="col-3 text-right"> <button type="button" class="btn btn-primary" data-dismiss="modal"><?php echo $datahub_button_cancel ?></button> </div> </div> </div> </div> </div> </div> </div> </body> </html>